import openpyxl

str1 = "胡"
str2 = "太长"
str = str1 + "_" + str2
print(str)


# workbook = xlrd.open_workbook(doc_data_dir + HOTLINE_INCIDENT_DIFFICULTY)
workbook = openpyxl.load_workbook(r"C:\Users\Administrator\Desktop\hotline_excel_to_be_optimized.xlsx")
# table1 = workbook.sheets()[0]
table1 = workbook['Sheet1']
for i in range(1, table1.max_row):
    info = table1.value(2)
    if len(info) <= 1:
        print(1)

